home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
ocukeys.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
2KB
|
42 lines
/* RCSVER $Id: ocukeys.sql,v 1.8 2000-03-22 15:35:39-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: ocukeys.sql
* Date: 01/18/1999
* memo: Randy Wood
* Description: Create the ocukeys table. This table defines all commands
* associated with the OCU keys.
* Changes:
************************************************************************* */
CREATE TABLE ocukeys
(
modifier VARCHAR2(1), /* Modifier key, or 'Q' if none */
key VARCHAR2(1), /* Key to which command is linked */
descr VARCHAR2(20), /* Description of command */
action_code VARCHAR2(1), /* Action to take: */
/* C: command */
/* F: fare */
/* S: fareset */
/* T: set trip */
/* D: inactive */
/* L: tally command */
command_id NUMBER(38), /* particular command ('C') */
fare_id NUMBER(38), /* fare, if action_code = 'F' */
fareset_id NUMBER(38), /* fareset, if action_code = 'S' */
trip_id NUMBER(1), /* 1=next trip, 2=prev trip 'T' */
sec_level NUMBER(38), /* security level of this function */
/* Can't have a zero reference, so for now these are removed */
/*
CONSTRAINT fk1_ocukeys FOREIGN KEY (command_id, config_num) REFERENCES
ocucmnd(id, config_num) ON DELETE CASCADE,
CONSTRAINT fk3_ocukeys FOREIGN KEY (fareset_id, config_num) REFERENCES
faresets(id, config_num) ON DELETE CASCADE,
*/
config_num NUMBER(38)
CONSTRAINT ref_ocukeys4 REFERENCES configset(num)
ON DELETE CASCADE,
tally_id NUMBER(38), /* Tally group */
CONSTRAINT pk_ocukeys PRIMARY KEY (modifier, key, config_num)
);